// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.


suite("test_cast_to_decimal256_76_38_from_str") {

    // This test case is generated from the correspoinding be UT test case,
    // update this case if the correspoinding be UT test case is updated,
    // e.g.: ../run-be-ut.sh --run --filter=FunctionCastToDecimalTest.* --gen_regression_case
    sql "set enable_decimal256 = true;"
    sql "drop table if exists test_cast_to_decimal256_76_38_from_str_15_nullable;"
    sql "create table test_cast_to_decimal256_76_38_from_str_15_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal256_76_38_from_str_15_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "9999999999999999999999999999999999999"),(6, "90000000000000000000000000000000000000"),(7, "90000000000000000000000000000000000001"),(8, "99999999999999999999999999999999999998"),(9, "99999999999999999999999999999999999999"),(10, "0."),(11, "1."),(12, "9."),(13, "9999999999999999999999999999999999999."),(14, "90000000000000000000000000000000000000."),(15, "90000000000000000000000000000000000001."),(16, "99999999999999999999999999999999999998."),(17, "99999999999999999999999999999999999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-9999999999999999999999999999999999999"),(22, "-90000000000000000000000000000000000000"),(23, "-90000000000000000000000000000000000001"),(24, "-99999999999999999999999999999999999998"),(25, "-99999999999999999999999999999999999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-9999999999999999999999999999999999999."),(30, "-90000000000000000000000000000000000000."),(31, "-90000000000000000000000000000000000001."),(32, "-99999999999999999999999999999999999998."),(33, "-99999999999999999999999999999999999999."),(34, ".000000000000000000000000000000000000004"),(35, ".000000000000000000000000000000000000014"),(36, ".000000000000000000000000000000000000094"),(37, ".099999999999999999999999999999999999994"),(38, ".900000000000000000000000000000000000004"),(39, ".900000000000000000000000000000000000014"),
      (40, ".999999999999999999999999999999999999984"),(41, ".999999999999999999999999999999999999994"),(42, ".000000000000000000000000000000000000005"),(43, ".000000000000000000000000000000000000015"),(44, ".000000000000000000000000000000000000095"),(45, ".099999999999999999999999999999999999995"),(46, ".900000000000000000000000000000000000005"),(47, ".900000000000000000000000000000000000015"),(48, ".999999999999999999999999999999999999985"),(49, ".999999999999999999999999999999999999994"),(50, "-.000000000000000000000000000000000000004"),(51, "-.000000000000000000000000000000000000014"),(52, "-.000000000000000000000000000000000000094"),(53, "-.099999999999999999999999999999999999994"),(54, "-.900000000000000000000000000000000000004"),(55, "-.900000000000000000000000000000000000014"),(56, "-.999999999999999999999999999999999999984"),(57, "-.999999999999999999999999999999999999994"),(58, "-.000000000000000000000000000000000000005"),(59, "-.000000000000000000000000000000000000015"),
      (60, "-.000000000000000000000000000000000000095"),(61, "-.099999999999999999999999999999999999995"),(62, "-.900000000000000000000000000000000000005"),(63, "-.900000000000000000000000000000000000015"),(64, "-.999999999999999999999999999999999999985"),(65, "-.999999999999999999999999999999999999994"),(66, "00000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "99999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "99999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "99999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "99999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "99999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "99999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "99999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "99999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "900000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "900000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "900000000000000000000000000000000000000000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "900000000000000000000000000000000000000999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "900000000000000000000000000000000000009000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "900000000000000000000000000000000000009000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "900000000000000000000000000000000000009999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "900000000000000000000000000000000000009999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "900000000000000000000000000000000000010000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "900000000000000000000000000000000000010000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "900000000000000000000000000000000000010000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "900000000000000000000000000000000000010999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "900000000000000000000000000000000000019000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "900000000000000000000000000000000000019000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "900000000000000000000000000000000000019999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "900000000000000000000000000000000000019999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "999999999999999999999999999999999999980000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "999999999999999999999999999999999999980000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "999999999999999999999999999999999999980000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "999999999999999999999999999999999999980999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "999999999999999999999999999999999999989000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "999999999999999999999999999999999999989000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "999999999999999999999999999999999999989999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "999999999999999999999999999999999999989999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "99999999999999999999999999999999999990000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "99999999999999999999999999999999999990000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "99999999999999999999999999999999999990000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "99999999999999999999999999999999999990999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "99999999999999999999999999999999999999000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "99999999999999999999999999999999999999000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "99999999999999999999999999999999999999999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "99999999999999999999999999999999999999999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "900000000000000000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "900000000000000000000000000000000000000000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "900000000000000000000000000000000000000000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "900000000000000000000000000000000000000999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "900000000000000000000000000000000000009000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "900000000000000000000000000000000000009000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "900000000000000000000000000000000000009999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "900000000000000000000000000000000000009999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "900000000000000000000000000000000000010000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "900000000000000000000000000000000000010000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "900000000000000000000000000000000000010000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "900000000000000000000000000000000000010999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "900000000000000000000000000000000000019000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "900000000000000000000000000000000000019000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "900000000000000000000000000000000000019999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "900000000000000000000000000000000000019999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "999999999999999999999999999999999999980000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "999999999999999999999999999999999999980000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "999999999999999999999999999999999999980000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "999999999999999999999999999999999999980999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "999999999999999999999999999999999999989000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "999999999999999999999999999999999999989000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "999999999999999999999999999999999999989999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "999999999999999999999999999999999999989999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-99999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-99999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-99999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-99999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-99999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-99999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-99999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-99999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-900000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-900000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-900000000000000000000000000000000000000000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-900000000000000000000000000000000000000999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-900000000000000000000000000000000000009000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-900000000000000000000000000000000000009000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-900000000000000000000000000000000000009999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-900000000000000000000000000000000000009999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-900000000000000000000000000000000000010000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-900000000000000000000000000000000000010000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-900000000000000000000000000000000000010000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-900000000000000000000000000000000000010999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-900000000000000000000000000000000000019000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-900000000000000000000000000000000000019000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-900000000000000000000000000000000000019999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-900000000000000000000000000000000000019999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-999999999999999999999999999999999999980000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-999999999999999999999999999999999999980000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-999999999999999999999999999999999999980000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-999999999999999999999999999999999999980999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-999999999999999999999999999999999999989000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-999999999999999999999999999999999999989000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-999999999999999999999999999999999999989999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-999999999999999999999999999999999999989999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-99999999999999999999999999999999999990000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-99999999999999999999999999999999999990000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-99999999999999999999999999999999999990000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-99999999999999999999999999999999999990999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-99999999999999999999999999999999999999000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-99999999999999999999999999999999999999000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-99999999999999999999999999999999999999999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-99999999999999999999999999999999999999999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-900000000000000000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-900000000000000000000000000000000000000000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-900000000000000000000000000000000000000000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-900000000000000000000000000000000000000999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-900000000000000000000000000000000000009000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-900000000000000000000000000000000000009000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-900000000000000000000000000000000000009999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-900000000000000000000000000000000000009999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-900000000000000000000000000000000000010000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-900000000000000000000000000000000000010000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-900000000000000000000000000000000000010000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-900000000000000000000000000000000000010999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-900000000000000000000000000000000000019000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-900000000000000000000000000000000000019000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-900000000000000000000000000000000000019999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-900000000000000000000000000000000000019999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-999999999999999999999999999999999999980000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-999999999999999999999999999999999999980000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-999999999999999999999999999999999999980000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-999999999999999999999999999999999999980999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-999999999999999999999999999999999999989000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-999999999999999999999999999999999999989000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-999999999999999999999999999999999999989999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-999999999999999999999999999999999999989999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100")
      ,(322, null);
    """

    sql "set enable_strict_cast=true;"
    qt_sql_15_strict 'select f1, cast(f2 as decimalv3(76, 38)) from test_cast_to_decimal256_76_38_from_str_15_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_15_non_strict 'select f1, cast(f2 as decimalv3(76, 38)) from test_cast_to_decimal256_76_38_from_str_15_nullable order by 1;'

    sql "drop table if exists test_cast_to_decimal256_76_38_from_str_15_not_nullable;"
    sql "create table test_cast_to_decimal256_76_38_from_str_15_not_nullable(f1 int, f2 string) properties('replication_num'='1');"
    sql """insert into test_cast_to_decimal256_76_38_from_str_15_not_nullable values (0, "0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(1, "-0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e2147483647"),(2, "0"),(3, "1"),(4, "9"),(5, "9999999999999999999999999999999999999"),(6, "90000000000000000000000000000000000000"),(7, "90000000000000000000000000000000000001"),(8, "99999999999999999999999999999999999998"),(9, "99999999999999999999999999999999999999"),(10, "0."),(11, "1."),(12, "9."),(13, "9999999999999999999999999999999999999."),(14, "90000000000000000000000000000000000000."),(15, "90000000000000000000000000000000000001."),(16, "99999999999999999999999999999999999998."),(17, "99999999999999999999999999999999999999."),(18, "-0"),(19, "-1"),
      (20, "-9"),(21, "-9999999999999999999999999999999999999"),(22, "-90000000000000000000000000000000000000"),(23, "-90000000000000000000000000000000000001"),(24, "-99999999999999999999999999999999999998"),(25, "-99999999999999999999999999999999999999"),(26, "-0."),(27, "-1."),(28, "-9."),(29, "-9999999999999999999999999999999999999."),(30, "-90000000000000000000000000000000000000."),(31, "-90000000000000000000000000000000000001."),(32, "-99999999999999999999999999999999999998."),(33, "-99999999999999999999999999999999999999."),(34, ".000000000000000000000000000000000000004"),(35, ".000000000000000000000000000000000000014"),(36, ".000000000000000000000000000000000000094"),(37, ".099999999999999999999999999999999999994"),(38, ".900000000000000000000000000000000000004"),(39, ".900000000000000000000000000000000000014"),
      (40, ".999999999999999999999999999999999999984"),(41, ".999999999999999999999999999999999999994"),(42, ".000000000000000000000000000000000000005"),(43, ".000000000000000000000000000000000000015"),(44, ".000000000000000000000000000000000000095"),(45, ".099999999999999999999999999999999999995"),(46, ".900000000000000000000000000000000000005"),(47, ".900000000000000000000000000000000000015"),(48, ".999999999999999999999999999999999999985"),(49, ".999999999999999999999999999999999999994"),(50, "-.000000000000000000000000000000000000004"),(51, "-.000000000000000000000000000000000000014"),(52, "-.000000000000000000000000000000000000094"),(53, "-.099999999999999999999999999999999999994"),(54, "-.900000000000000000000000000000000000004"),(55, "-.900000000000000000000000000000000000014"),(56, "-.999999999999999999999999999999999999984"),(57, "-.999999999999999999999999999999999999994"),(58, "-.000000000000000000000000000000000000005"),(59, "-.000000000000000000000000000000000000015"),
      (60, "-.000000000000000000000000000000000000095"),(61, "-.099999999999999999999999999999999999995"),(62, "-.900000000000000000000000000000000000005"),(63, "-.900000000000000000000000000000000000015"),(64, "-.999999999999999999999999999999999999985"),(65, "-.999999999999999999999999999999999999994"),(66, "00000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(67, "00000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(68, "00000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(69, "00999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(70, "09000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(71, "09000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(72, "09999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(73, "09999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(74, "10000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(75, "10000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(76, "10000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(77, "10999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(78, "19000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(79, "19000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (80, "19999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(81, "19999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(82, "90000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(83, "90000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(84, "90000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(85, "90999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(86, "99000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(87, "99000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(88, "99999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(89, "99999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(90, "99999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(91, "99999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(92, "99999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(93, "99999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(94, "99999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(95, "99999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(96, "99999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(97, "99999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(98, "900000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(99, "900000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (100, "900000000000000000000000000000000000000000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(101, "900000000000000000000000000000000000000999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(102, "900000000000000000000000000000000000009000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(103, "900000000000000000000000000000000000009000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(104, "900000000000000000000000000000000000009999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(105, "900000000000000000000000000000000000009999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(106, "900000000000000000000000000000000000010000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(107, "900000000000000000000000000000000000010000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(108, "900000000000000000000000000000000000010000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(109, "900000000000000000000000000000000000010999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(110, "900000000000000000000000000000000000019000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(111, "900000000000000000000000000000000000019000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(112, "900000000000000000000000000000000000019999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(113, "900000000000000000000000000000000000019999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(114, "999999999999999999999999999999999999980000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(115, "999999999999999999999999999999999999980000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(116, "999999999999999999999999999999999999980000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(117, "999999999999999999999999999999999999980999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(118, "999999999999999999999999999999999999989000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(119, "999999999999999999999999999999999999989000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (120, "999999999999999999999999999999999999989999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(121, "999999999999999999999999999999999999989999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(122, "999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(123, "999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(124, "999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(125, "999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(126, "999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(127, "999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(128, "999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(129, "999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(130, "00000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(131, "00000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(132, "00000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(133, "00999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(134, "09000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(135, "09000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(136, "09999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(137, "09999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(138, "10000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(139, "10000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (140, "10000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(141, "10999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(142, "19000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(143, "19000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(144, "19999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(145, "19999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(146, "90000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(147, "90000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(148, "90000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(149, "90999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(150, "99000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(151, "99000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(152, "99999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(153, "99999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(154, "99999999999999999999999999999999999990000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(155, "99999999999999999999999999999999999990000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(156, "99999999999999999999999999999999999990000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(157, "99999999999999999999999999999999999990999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(158, "99999999999999999999999999999999999999000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(159, "99999999999999999999999999999999999999000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (160, "99999999999999999999999999999999999999999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(161, "99999999999999999999999999999999999999999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(162, "900000000000000000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(163, "900000000000000000000000000000000000000000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(164, "900000000000000000000000000000000000000000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(165, "900000000000000000000000000000000000000999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(166, "900000000000000000000000000000000000009000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(167, "900000000000000000000000000000000000009000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(168, "900000000000000000000000000000000000009999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(169, "900000000000000000000000000000000000009999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(170, "900000000000000000000000000000000000010000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(171, "900000000000000000000000000000000000010000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(172, "900000000000000000000000000000000000010000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(173, "900000000000000000000000000000000000010999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(174, "900000000000000000000000000000000000019000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(175, "900000000000000000000000000000000000019000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(176, "900000000000000000000000000000000000019999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(177, "900000000000000000000000000000000000019999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(178, "999999999999999999999999999999999999980000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(179, "999999999999999999999999999999999999980000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (180, "999999999999999999999999999999999999980000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(181, "999999999999999999999999999999999999980999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(182, "999999999999999999999999999999999999989000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(183, "999999999999999999999999999999999999989000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(184, "999999999999999999999999999999999999989999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(185, "999999999999999999999999999999999999989999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(186, "999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(187, "999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(188, "999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(189, "999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(190, "999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(191, "999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(192, "999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(193, "999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(194, "-00000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(195, "-00000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(196, "-00000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(197, "-00999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(198, "-09000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(199, "-09000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (200, "-09999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(201, "-09999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(202, "-10000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(203, "-10000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(204, "-10000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(205, "-10999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(206, "-19000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(207, "-19000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(208, "-19999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(209, "-19999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(210, "-90000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(211, "-90000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(212, "-90000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(213, "-90999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(214, "-99000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(215, "-99000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(216, "-99999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(217, "-99999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(218, "-99999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(219, "-99999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (220, "-99999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(221, "-99999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(222, "-99999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(223, "-99999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(224, "-99999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(225, "-99999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(226, "-900000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(227, "-900000000000000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(228, "-900000000000000000000000000000000000000000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(229, "-900000000000000000000000000000000000000999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(230, "-900000000000000000000000000000000000009000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(231, "-900000000000000000000000000000000000009000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(232, "-900000000000000000000000000000000000009999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(233, "-900000000000000000000000000000000000009999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(234, "-900000000000000000000000000000000000010000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(235, "-900000000000000000000000000000000000010000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(236, "-900000000000000000000000000000000000010000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(237, "-900000000000000000000000000000000000010999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(238, "-900000000000000000000000000000000000019000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(239, "-900000000000000000000000000000000000019000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (240, "-900000000000000000000000000000000000019999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(241, "-900000000000000000000000000000000000019999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(242, "-999999999999999999999999999999999999980000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(243, "-999999999999999999999999999999999999980000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(244, "-999999999999999999999999999999999999980000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(245, "-999999999999999999999999999999999999980999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(246, "-999999999999999999999999999999999999989000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(247, "-999999999999999999999999999999999999989000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(248, "-999999999999999999999999999999999999989999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(249, "-999999999999999999999999999999999999989999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(250, "-999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(251, "-999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(252, "-999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(253, "-999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(254, "-999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(255, "-999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(256, "-999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(257, "-999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(258, "-00000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(259, "-00000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (260, "-00000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(261, "-00999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(262, "-09000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(263, "-09000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(264, "-09999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(265, "-09999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(266, "-10000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(267, "-10000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(268, "-10000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(269, "-10999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(270, "-19000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(271, "-19000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(272, "-19999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(273, "-19999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(274, "-90000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(275, "-90000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(276, "-90000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(277, "-90999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(278, "-99000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(279, "-99000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (280, "-99999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(281, "-99999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(282, "-99999999999999999999999999999999999990000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(283, "-99999999999999999999999999999999999990000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(284, "-99999999999999999999999999999999999990000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(285, "-99999999999999999999999999999999999990999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(286, "-99999999999999999999999999999999999999000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(287, "-99999999999999999999999999999999999999000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(288, "-99999999999999999999999999999999999999999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(289, "-99999999999999999999999999999999999999999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(290, "-900000000000000000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(291, "-900000000000000000000000000000000000000000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(292, "-900000000000000000000000000000000000000000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(293, "-900000000000000000000000000000000000000999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(294, "-900000000000000000000000000000000000009000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(295, "-900000000000000000000000000000000000009000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(296, "-900000000000000000000000000000000000009999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(297, "-900000000000000000000000000000000000009999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(298, "-900000000000000000000000000000000000010000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(299, "-900000000000000000000000000000000000010000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),
      (300, "-900000000000000000000000000000000000010000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(301, "-900000000000000000000000000000000000010999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(302, "-900000000000000000000000000000000000019000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(303, "-900000000000000000000000000000000000019000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(304, "-900000000000000000000000000000000000019999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(305, "-900000000000000000000000000000000000019999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(306, "-999999999999999999999999999999999999980000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(307, "-999999999999999999999999999999999999980000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(308, "-999999999999999999999999999999999999980000000000000000000000000000000000000950000000000000000000000000000000000000000000000000000000000000.e-100"),(309, "-999999999999999999999999999999999999980999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(310, "-999999999999999999999999999999999999989000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000.e-100"),(311, "-999999999999999999999999999999999999989000000000000000000000000000000000000150000000000000000000000000000000000000000000000000000000000000.e-100"),(312, "-999999999999999999999999999999999999989999999999999999999999999999999999999850000000000000000000000000000000000000000000000000000000000000.e-100"),(313, "-999999999999999999999999999999999999989999999999999999999999999999999999999950000000000000000000000000000000000000000000000000000000000000.e-100"),(314, "-999999999999999999999999999999999999990000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(315, "-999999999999999999999999999999999999990000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),(316, "-999999999999999999999999999999999999990000000000000000000000000000000000000940000000000000000000000000000000000000000000000000000000000000.e-100"),(317, "-999999999999999999999999999999999999990999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100"),(318, "-999999999999999999999999999999999999999000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000.e-100"),(319, "-999999999999999999999999999999999999999000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000.e-100"),
      (320, "-999999999999999999999999999999999999999999999999999999999999999999999999999840000000000000000000000000000000000000000000000000000000000000.e-100"),(321, "-999999999999999999999999999999999999999999999999999999999999999999999999999940000000000000000000000000000000000000000000000000000000000000.e-100");
    """

    sql "set enable_strict_cast=true;"
    qt_sql_15_strict 'select f1, cast(f2 as decimalv3(76, 38)) from test_cast_to_decimal256_76_38_from_str_15_not_nullable order by 1;'

    sql "set enable_strict_cast=false;"
    qt_sql_15_non_strict 'select f1, cast(f2 as decimalv3(76, 38)) from test_cast_to_decimal256_76_38_from_str_15_not_nullable order by 1;'

}